<?php

namespace App\Jobs\Publish;

use Illuminate\Bus\Queueable;
use Illuminate\Queue\SerializesModels;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Bus\Dispatchable;
use Illuminate\Support\Facades\DB;
use App\Models\Entity\Pm\Pmtag;
use App\Http\Controllers\Entity\Pm\PriceController;
use App\Models\Entity\Pm\PmtagVasseti;
use App\Classes\Publish\Publication;
use App\Models\Task\Task;

class PmtagJob implements ShouldQueue
{
    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;
    protected $ids;
    protected $option;
    public $tries   = 1;
    public $timeout = 30;
    public $taskid;
    // 上线,下线,发布的where条件
    protected $upWhere          = ['online_status' => 0, 'publish_down_status' => 1];
    protected $publishWhere     = ['online_status' => 1, 'publish_status'      => 0];
    protected $downWhere        = ['online_status' => 1];
    protected $publishDownWhere = ['online_status' => 0, 'publish_down_status' => 0];
    /**
     * Create a new job instance.
     *
     * @return void
     */
    public function __construct($option, $ids = '', $taskid = '')
    {
        $this->option  = $option;
        $this->ids     = $ids;
        $this->taskid  = $taskid;
    }

    /**
     * Execute the job.
     *
     * @return void
     */
    public function handle()
    {
        switch ($this->option[0]) {
            // 分发任务,将一个大任务划分为多个小任务
            case 'dispatch':
                $this->mydispatch($this->option[1]);
                break;
            // 上线小任务
            case 'up':
                $user_id = Publication::getField(new Task(), $this->taskid, 'user_id');
                // 过滤有媒资的产品包
                $hasVassetiIds = PmtagVasseti::whereIn('pmtag_id', $this->ids)->pluck('pmtag_id')->unique();
                Publication::updateMany(new Pmtag(), $hasVassetiIds, [
                    'online_status'       => 1, 
                    'publish_down_status' => 0, 
                    'user_id'             => $user_id, 
                    'online_at'           => date('Y-m-d H:i:s')
                ]);
                Publication::updateOne(new Task(), $this->taskid, [
                    // 已经完成的数量是有媒资产品包的总数
                    'done_num'  => DB::raw('done_num +'.count($hasVassetiIds)),
                ]);
                break;
            // 发布小任务
            case 'publish':
                $publish_small_chunk_num = config('custom.base.job.pmtag.publish_small_chunk_num');
                foreach ($this->ids->chunk($publish_small_chunk_num) as $chunk_ids) {
                    try {
                        $pmtags = Pmtag::whereIn('id',$chunk_ids)->get();
                        // 将产品包媒资中间表数据插入接口库
                        $total_num = $pmtags->count();
                        PmtagVasseti::whereIn('pmtag_id', $chunk_ids)->chunk($publish_small_chunk_num, function($pmtag_vassetis) use (&$total_num){
                            $pmtagVassetiDatas = self::makePmtagVassetis($pmtag_vassetis);
                            DB::connection('interface')->table('pmtag_vassetis')->insert($pmtagVassetiDatas);
                        });
                    } catch(\Exception $e) {
                        dd($e->getMessage());
                    }
                    // 拼装产品包数据, 产品包-媒资中间表数据
                    $pmtag_datas = self::makePmtags($pmtags);
                    DB::connection('interface')->beginTransaction();
                    try {
                        DB::connection('interface')->table('pmtags')->insert($pmtag_datas);
                        DB::connection('interface')->commit();
                        Publication::updateMany(new Pmtag(), $chunk_ids, ['publish_status' => 1]);
                        Publication::updateOne(new Task(), $this->taskid, [
                            'done_num' => DB::raw('done_num + ' . $total_num)
                        ]);
                    } catch (\Exception $e) {
                        DB::connection('interface')->rollback(); //事务回滚
                        dd($e->getMessage());
                    }
                }
                break;
            // 下线小任务
            case 'down':
                $user_id = Publication::getField(new Task(), $this->taskid, 'user_id');
                Publication::updateMany(new Pmtag(), $this->ids, [
                    'online_status'  => 0, 
                    'publish_status' => 0, 
                    'user_id'        => $user_id, 
                    'offline_at'     => date('Y-m-d H:i:s')
                ]);
                Publication::updateOne(new Task(), $this->taskid, ['done_num' => DB::raw('done_num +' . count($this->ids))]);
                break;
            // 下线发布小任务
            case 'publishDown':
                $user_id = Publication::getField(new Task(), $this->taskid,'user_id');
                Publication::deleteApi('pmtags', 'pmtag_id', $this->ids);
                Publication::deleteApi('pmtag_vassetis', 'pmtag_id', $this->ids);
                $done_num = Publication::getTotal(new PmtagVasseti(), 'pmtag_id' ,$this->ids);
                Publication::updateMany(new Pmtag(), $this->ids, [
                    'publish_down_status' => 1, 
                    'user_id'             => $user_id, 
                ]);
                Publication::updateOne(new Task(), $this->taskid, ['done_num' => DB::raw('done_num +' . count($this->ids))]);
                break;
        }
    }
    
    /**
    * 分发任务具体执行代码
    */
    public function mydispatch($option)
    {
        switch ($option) {
            case 'up':
                $chunk_num = config('custom.base.job.pmtag.online_chunk_num');
                $where = $this->upWhere;
                break;
            case 'publish':
                $chunk_num = config('custom.base.job.pmtag.publish_chunk_num');
                $where = $this->publishWhere;
                break;
            case 'down':
                $chunk_num = config('custom.base.job.pmtag.offline_chunk_num');
                $where = $this->downWhere;
                break;
            case 'publishDown':
                $chunk_num = config('custom.base.job.pmtag.publish_chunk_num');
                $where = $this->publishDownWhere;
                break;
        }
        Publication::chunk(new Pmtag(), $this, $where, $chunk_num, [$option]);
    }

     
    /**
    * 拼装产品包数据
    */
    public static function makePmtags($pmtags)
    {
        $datas = [];
        $data  = [];
        foreach ($pmtags as $pmtag) {
            $data['pmtag_id']         = $pmtag->id;
            $data['name']       = $pmtag->name;
            $data['title']      = $pmtag->title;
            $data['subtitle']   = $pmtag->subtitle;
            $data['short_desc'] = $pmtag->short_desc;
            $data['images']     = $pmtag->images;
            $data['sdk_id']     = $pmtag->sdk_id;
            $data['keyword']    = $pmtag->keyword;
            $data['status']     = $pmtag->status;
            $datas[]            = $data;
        }
        return $datas;
    }

    /**
    * 拼装产品包数据媒资中间表数据
    */
    public static function makePmtagVassetis($pmtag_vassetis)
    {
        $datas = [];
        $data  = [];
        foreach ($pmtag_vassetis as $pmtag_vasseti) {
            $data['pmtag_id']   = $pmtag_vasseti->pmtag_id;
            $data['vasseti_id'] = $pmtag_vasseti->vasseti_id;
            $datas[]            = $data;
        }
        return $datas;
    }
}
